SELECT
SQL_CALC_FOUND_ROWS products.product_id,
descr1.product as product,
companies.company as company_name,
companies.ec_rfq_whatsapp_number,
companies.ec_rfq_bht,
companies.ec_rfq_phone_number,
companies.ec_rfq_bhf,
products.product_type,
products.parent_product_id,
cscart_ec_table_booking_system.booking_type as booking_type
FROM
cscart_products as products
LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id
AND descr1.lang_code = 'en'
LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id
AND prices.lower_limit = 1
LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id
INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id
INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id
AND (
cscart_categories.usergroup_ids = ''
OR FIND_IN_SET(
0, cscart_categories.usergroup_ids
)
OR FIND_IN_SET(
1, cscart_categories.usergroup_ids
)
)
AND cscart_categories.status IN ('A', 'H')
AND cscart_categories.storefront_id IN (0, 1)
LEFT JOIN cscart_ec_table_booking_system ON cscart_ec_table_booking_system.product_id = products.product_id
LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id
WHERE
1
AND companies.status IN ('A')
AND products.company_id IN (
1,
25,
34,
35,
36,
37,
38,
39,
40,
41,
42,
43,
44,
45,
46,
47,
48,
49,
50,
51,
52,
53,
54,
55,
56,
57,
58,
59,
60,
61,
62,
63,
64,
65,
66,
67,
68,
69,
70,
71,
72,
73,
74,
75,
76,
77,
78,
79,
81,
82,
83,
84,
85,
86,
87,
88,
89,
90,
91,
92,
93,
94,
95,
96,
97,
98,
99,
100,
101,
102,
103,
104,
105,
106,
108,
109,
110,
111,
122,
123,
124,
125,
126,
127,
128,
129,
130,
131,
132,
134,
135,
136,
137,
138,
139,
140,
141,
142,
143,
144,
145,
146,
148,
150,
152,
153,
154,
155,
156,
157,
158,
159,
160,
161,
162,
163,
164,
165,
166,
167,
168,
169,
170,
171,
172,
173,
174,
175,
176,
177,
178,
179,
180,
181,
182,
183,
184,
185,
186,
187,
188,
189,
190,
191,
192,
193,
194,
196,
197,
198,
199,
200,
202,
203,
204,
205,
206,
207,
208,
210,
211,
212,
213,
214,
215,
216,
217,
218,
219,
220,
221,
222,
223,
224,
225,
226,
227,
228,
229,
230,
231,
232,
233,
234,
235,
236,
237,
238,
239,
240,
241,
242,
243,
244,
245,
246,
247,
248,
249,
250,
251,
252,
253,
254,
255,
256,
257,
259,
260,
261,
262,
263,
264,
266,
268,
269,
271,
272,
273,
276,
277,
278,
279,
280,
281,
282,
284,
285,
286,
287,
288,
289,
290,
291,
292,
293,
294,
295,
296,
297,
298,
299,
300,
301,
302,
303,
304,
305,
306,
307,
308,
309,
310,
311,
312,
313,
314,
315,
316,
317,
318,
319,
321,
322,
323,
324,
325,
326,
327,
328,
329,
330,
331,
332,
333,
334,
335,
336,
337,
338,
339,
340,
341,
342,
343,
344,
345,
346,
347,
348,
349,
350,
351,
352,
353,
354,
355,
356,
357,
358,
359,
360,
361,
362,
363,
364,
365,
366,
367,
368,
369,
370,
371,
372,
373,
374,
377,
378,
379,
380,
381,
382,
383,
384,
385,
387,
388,
389,
391,
392,
393,
394,
395,
396,
397,
398,
400,
401,
402,
403,
404,
405,
406,
407,
408,
409,
410,
411,
414,
415,
416,
417,
418,
419,
420,
421,
422,
423,
424,
425,
426,
427,
428,
429,
430,
431,
432,
433,
434,
435,
436,
439,
440,
443,
445,
447,
448,
449,
450,
451,
452,
454,
455,
457,
458,
459,
460,
461,
462,
463,
465,
466,
467,
468,
469,
470,
471,
472,
473,
474,
476,
478,
479,
480,
481,
482,
483,
484,
485,
486,
487,
488,
489,
491,
492,
493,
494,
495,
496,
497,
498,
501,
503,
504,
505,
507,
508,
509,
510,
511,
512,
513,
514,
515,
516,
518,
519,
520,
522,
524,
525,
526,
527,
528,
531,
532,
533,
535,
537,
539,
540,
541,
542,
543,
545,
546,
547,
548,
549,
550,
551,
553,
554,
556,
557,
558,
559,
560,
561,
562,
563,
564,
566,
567,
568,
569,
575,
576,
577,
579,
580,
582,
583,
585,
586,
587,
588,
590,
591,
592,
593,
594,
595,
596,
597,
598,
600,
602,
603,
604,
606,
607,
609,
610,
611,
613,
618,
620,
621,
622,
623,
624,
625,
626,
627,
628,
629,
630,
631,
632,
633,
634,
635,
636,
637,
639,
641,
642,
643,
644,
646,
647,
649,
655,
660,
661,
662,
663,
665,
668,
669,
670,
671,
672,
673,
674,
675,
676,
678,
679,
680,
681,
682,
685,
686,
687,
688,
689,
690,
691,
692,
693,
694,
695,
696,
697,
707,
719,
0
)
AND products.amount >= 1
AND (
products.usergroup_ids = ''
OR FIND_IN_SET(0, products.usergroup_ids)
OR FIND_IN_SET(1, products.usergroup_ids)
)
AND products.status IN ('A')
AND prices.usergroup_id IN (0, 0, 1)
AND 1 != 1
GROUP BY
products.product_id
ORDER BY
popularity.total desc,
products.product_id ASC
LIMIT
0, 10