Buy Chairs Collection Online in Dubai, Abu Dhabi, Sharjah, UAE

select products.id, products.title, products.sku, products.title, products.slug, products.variant01, products.variant02, products.variant03, products.variant04, products.price, products.offerprice from products where products.publish='y' and id in (344,533,534,535,536,537,538,539,540,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,703,704,705,706,707,708,709,710,711,712,713,714,715,716,717,718,719,720,721,722,723,724,725,726,727,728,730,731,732,733,734,735,736,737,738,739,740,741,825,826,827,828,829,836,859,860,863,872,873,874,875,877,879,880,881,882,883,884,885,886,888,890,891,892,893,894,895,897,898,899,900,901,902,903,904,905,906,907,908,910,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,937,938,939,940,941,942,943,860,915,583,601,700,915,533,534,536,537,539,540,544,545,550,552,553,554,557,560,563,566,568,569,570,572,574,576,579,586,590,593,594,596,597,598,600,603,604,605,606,608,609,610,619,645,647,649,651,653,655,658,660,663,665,667,668,669,670,680,681,683,684,685,687,688,689,694,695,696,697,698,701,704,708,711,714,717,720,723,725,727,733,825,826,827,828,830,831,835,858,859,862,863,864,874,875,880,883,885,891,898,900,902,903,904,905,907,910,917,919,921,929,930,937,938,941,533,534,536,537,539,540,545,548,555,563,564,580,594,598,619,655,659,661,664,680,690,691,709,712,715,718,721,728,730,731,825,826,864,873,874,884,902,908,912,929,930,931,932,934,554,555,557,558,560,561,563,564,576,583,601,659,664,666,680,684,864,874,884,912,929,930,931,932,584,737,739,741,535,537,538,543,546,548,549,551,555,556,559,561,562,564,565,567,571,573,575,578,581,587,589,591,592,595,599,607,611,613,646,648,650,652,654,656,662,682,686,692,693,699,710,713,716,719,722,724,726,732,735,829,832,833,834,836,846,861,872,877,879,882,895,897,908,931,934,558,561,564,577,580,588,602,657,659,661,664,666,671,690,691,702,703,705,706,707,734,736,864,873,884,908,912,916,939,940,943,344,554,555,558,560,561,563,564,577,580,582,585,612,659,664,666,671,690,691,702,703,705,706,707,728,730,731,734,736,873,874,881,884,886,888,890,892,893,894,899,901,906,908,912,913,914,916,918,920,922,929,930,931,932,933,939,940,942,943,614,615,616,617,618,738,740,923,924,925,926,927,928) order by FIELD(products.id, 619,645,646,647,655,648,649,650,651,652,653,654,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,680,681,682,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,700,701,702,703,704,705,706,707,603,604,605,606,607,610,611,612,552,596,568,569,554,555,556,558,559,560,561,562,582,579,580,581,602,588,547,548,549,550,551,566,567,570,571,572,573,574,575,584,586,587,593,594,595,597,598,599,544,546,533,534,536,537,538,539,540,543,545,614,615,616,617,618,592,589,601,583) LIMIT 0, 18 189 Results Found

Sort By: